Dataset statistics
| Number of variables | 41 |
|---|---|
| Number of observations | 70372 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 22.0 MiB |
| Average record size in memory | 328.0 B |
Variable types
| BOOL | 29 |
|---|---|
| NUM | 9 |
| DATE | 3 |
tot_contribution_paid_amt is highly skewed (γ1 = 69.13668969) | Skewed |
Lifetime Giving is highly skewed (γ1 = 30.32802605) | Skewed |
tot_ticket_paid_amt has 953 (1.4%) zeros | Zeros |
tot_contribution_paid_amt has 68563 (97.4%) zeros | Zeros |
Prelim Capacity has 30829 (43.8%) zeros | Zeros |
Lifetime Giving has 58829 (83.6%) zeros | Zeros |
days_to_donation has 58782 (83.5%) zeros | Zeros |
Reproduction
| Analysis started | 2020-09-08 20:03:36.337975 |
|---|---|
| Analysis finished | 2020-09-08 20:04:59.267828 |
| Duration | 1 minute and 22.93 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
owner_no
Real number (ℝ≥0)
| Distinct | 38522 |
|---|---|
| Distinct (%) | 54.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2022525.081 |
|---|---|
| Minimum | 111 |
| Maximum | 2419301 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 549.8 KiB |
Quantile statistics
| Minimum | 111 |
|---|---|
| 5-th percentile | 397258.05 |
| Q1 | 1928112 |
| median | 2370216.5 |
| Q3 | 2391456 |
| 95-th percentile | 2413551.9 |
| Maximum | 2419301 |
| Range | 2419190 |
| Interquartile range (IQR) | 463344 |
Descriptive statistics
| Standard deviation | 629695.9448 |
|---|---|
| Coefficient of variation (CV) | 0.3113414765 |
| Kurtosis | 2.187826958 |
| Mean | 2022525.081 |
| Median Absolute Deviation (MAD) | 40994.5 |
| Skewness | -1.835938465 |
| Sum | 1.42329135e+11 |
| Variance | 3.965169829e+11 |
| Monotocity | Increasing |
| Value | Count | Frequency (%) | |
| 2335299 | 66 | 0.1% | |
| 1485790 | 64 | 0.1% | |
| 275098 | 48 | 0.1% | |
| 2289267 | 47 | 0.1% | |
| 2373627 | 47 | 0.1% | |
| 2140595 | 46 | 0.1% | |
| 2133270 | 44 | 0.1% | |
| 2375331 | 43 | 0.1% | |
| 2388599 | 43 | 0.1% | |
| 2387926 | 42 | 0.1% | |
| Other values (38512) | 69882 | 99.3% |
| Value | Count | Frequency (%) | |
| 111 | 3 | < 0.1% | |
| 258 | 1 | < 0.1% | |
| 262 | 2 | < 0.1% | |
| 267 | 5 | < 0.1% | |
| 853 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2419301 | 1 | < 0.1% | |
| 2419278 | 1 | < 0.1% | |
| 2419248 | 1 | < 0.1% | |
| 2419126 | 1 | < 0.1% | |
| 2419011 | 1 | < 0.1% |
order_dt
Date
| Distinct | 2160 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| Minimum | 2014-01-01 00:00:00 |
|---|---|
| Maximum | 2020-02-29 00:00:00 |
| Distinct | 1159 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.5573702184 |
|---|---|
| Minimum | -0.1276523274 |
| Maximum | 34.33847607 |
| Zeros | 953 |
| Zeros (%) | 1.4% |
| Memory size | 549.8 KiB |
Quantile statistics
| Minimum | -0.1276523274 |
|---|---|
| 5-th percentile | -0.1276523274 |
| Q1 | -0.1276523274 |
| median | 0 |
| Q3 | 0.8723476726 |
| 95-th percentile | 2.629637945 |
| Maximum | 34.33847607 |
| Range | 34.4661284 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.262070333 |
|---|---|
| Coefficient of variation (CV) | 2.264330405 |
| Kurtosis | 64.08996281 |
| Mean | 0.5573702184 |
| Median Absolute Deviation (MAD) | 0.1276523274 |
| Skewness | 5.40552422 |
| Sum | 39223.25701 |
| Variance | 1.592821524 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| -0.1276523274 | 34085 | 48.4% | |
| 0.1276523274 | 1032 | 1.5% | |
| 0 | 953 | 1.4% | |
| 1.136105714 | 793 | 1.1% | |
| 0.1148870947 | 761 | 1.1% | |
| 0.7531487317 | 714 | 1.0% | |
| 1.391410369 | 695 | 1.0% | |
| 0.2553046548 | 675 | 1.0% | |
| 0.5106093097 | 659 | 0.9% | |
| 0.1914784911 | 633 | 0.9% | |
| Other values (1149) | 29372 | 41.7% |
| Value | Count | Frequency (%) | |
| -0.1276523274 | 34085 | 48.4% | |
| -0.121269711 | 1 | < 0.1% | |
| -0.1148870947 | 4 | < 0.1% | |
| -0.1085044783 | 1 | < 0.1% | |
| -0.1021218619 | 14 | < 0.1% |
| Value | Count | Frequency (%) | |
| 34.33847607 | 1 | < 0.1% | |
| 32.93430047 | 1 | < 0.1% | |
| 29.15579158 | 1 | < 0.1% | |
| 28.04521633 | 1 | < 0.1% | |
| 27.26653714 | 1 | < 0.1% |
| Distinct | 131 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.020798045 |
|---|---|
| Minimum | 0 |
| Maximum | 5000 |
| Zeros | 68563 |
| Zeros (%) | 97.4% |
| Memory size | 549.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 5000 |
| Range | 5000 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 42.71554863 |
|---|---|
| Coefficient of variation (CV) | 21.1379602 |
| Kurtosis | 6497.137924 |
| Mean | 2.020798045 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 69.13668969 |
| Sum | 142207.6 |
| Variance | 1824.618095 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 68563 | 97.4% | |
| 100 | 334 | 0.5% | |
| 10 | 217 | 0.3% | |
| 25 | 183 | 0.3% | |
| 50 | 128 | 0.2% | |
| 20 | 125 | 0.2% | |
| 5 | 97 | 0.1% | |
| 40 | 76 | 0.1% | |
| 2 | 47 | 0.1% | |
| 250 | 32 | < 0.1% | |
| Other values (121) | 570 | 0.8% |
| Value | Count | Frequency (%) | |
| 0 | 68563 | 97.4% | |
| 1 | 21 | < 0.1% | |
| 1.5 | 1 | < 0.1% | |
| 2 | 47 | 0.1% | |
| 2.2 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5000 | 2 | < 0.1% | |
| 2500 | 5 | < 0.1% | |
| 2250 | 1 | < 0.1% | |
| 2000 | 2 | < 0.1% | |
| 1500 | 1 | < 0.1% |
first_order_dt
Date
| Distinct | 2931 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| Minimum | 2010-01-10 00:00:00 |
|---|---|
| Maximum | 2020-02-29 00:00:00 |
first_cont_dt
Date
| Distinct | 1398 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| Minimum | 1900-01-01 00:00:00 |
|---|---|
| Maximum | 2020-08-20 00:00:00 |
geo_area_desc
Real number (ℝ≥0)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.674103337 |
|---|---|
| Minimum | 1 |
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 549.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 6 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.497853338 |
|---|---|
| Coefficient of variation (CV) | 0.8947197612 |
| Kurtosis | 5.987047599 |
| Mean | 1.674103337 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.620774255 |
| Sum | 117810 |
| Variance | 2.243564621 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 51168 | 72.7% | |
| 2 | 10277 | 14.6% | |
| 7 | 3473 | 4.9% | |
| 3 | 2428 | 3.5% | |
| 5 | 1503 | 2.1% | |
| 4 | 1080 | 1.5% | |
| 6 | 443 | 0.6% |
| Value | Count | Frequency (%) | |
| 1 | 51168 | 72.7% | |
| 2 | 10277 | 14.6% | |
| 3 | 2428 | 3.5% | |
| 4 | 1080 | 1.5% | |
| 5 | 1503 | 2.1% |
| Value | Count | Frequency (%) | |
| 7 | 3473 | 4.9% | |
| 6 | 443 | 0.6% | |
| 5 | 1503 | 2.1% | |
| 4 | 1080 | 1.5% | |
| 3 | 2428 | 3.5% |
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.910319445 |
|---|---|
| Minimum | 0 |
| Maximum | 10 |
| Zeros | 30829 |
| Zeros (%) | 43.8% |
| Memory size | 549.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 1.946138595 |
|---|---|
| Coefficient of variation (CV) | 1.018750345 |
| Kurtosis | -1.09127187 |
| Mean | 1.910319445 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.4400920866 |
| Sum | 134433 |
| Variance | 3.787455429 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 30829 | 43.8% | |
| 4 | 11622 | 16.5% | |
| 3 | 11043 | 15.7% | |
| 2 | 6672 | 9.5% | |
| 5 | 5271 | 7.5% | |
| 1 | 2997 | 4.3% | |
| 6 | 1611 | 2.3% | |
| 7 | 181 | 0.3% | |
| 8 | 130 | 0.2% | |
| 9 | 13 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 30829 | 43.8% | |
| 1 | 2997 | 4.3% | |
| 2 | 6672 | 9.5% | |
| 3 | 11043 | 15.7% | |
| 4 | 11622 | 16.5% |
| Value | Count | Frequency (%) | |
| 10 | 3 | < 0.1% | |
| 9 | 13 | < 0.1% | |
| 8 | 130 | 0.2% | |
| 7 | 181 | 0.3% | |
| 6 | 1611 | 2.3% |
ltv_tkt_value
Real number (ℝ)
| Distinct | 2560 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.201675607 |
|---|---|
| Minimum | -0.2779850746 |
| Maximum | 78.66231343 |
| Zeros | 59 |
| Zeros (%) | 0.1% |
| Memory size | 549.8 KiB |
Quantile statistics
| Minimum | -0.2779850746 |
|---|---|
| 5-th percentile | -0.2779850746 |
| Q1 | -0.2779850746 |
| median | 0 |
| Q3 | 0.7220149254 |
| 95-th percentile | 6.699626866 |
| Maximum | 78.66231343 |
| Range | 78.94029851 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 4.525258255 |
|---|---|
| Coefficient of variation (CV) | 3.765790224 |
| Kurtosis | 94.91915165 |
| Mean | 1.201675607 |
| Median Absolute Deviation (MAD) | 0.2779850746 |
| Skewness | 8.256546927 |
| Sum | 84564.31584 |
| Variance | 20.47796228 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| -0.2779850746 | 21484 | 30.5% | |
| -0.203358209 | 782 | 1.1% | |
| -0.2406716418 | 758 | 1.1% | |
| -0.1660447761 | 564 | 0.8% | |
| -0.2070895522 | 500 | 0.7% | |
| -0.02052238806 | 492 | 0.7% | |
| 0.1660447761 | 476 | 0.7% | |
| 0.09141791045 | 464 | 0.7% | |
| -0.1324626866 | 452 | 0.6% | |
| -0.0578358209 | 430 | 0.6% | |
| Other values (2550) | 43970 | 62.5% |
| Value | Count | Frequency (%) | |
| -0.2779850746 | 21484 | 30.5% | |
| -0.2742537313 | 2 | < 0.1% | |
| -0.2705223881 | 13 | < 0.1% | |
| -0.2686567164 | 7 | < 0.1% | |
| -0.2667910448 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 78.66231343 | 31 | < 0.1% | |
| 61.79477612 | 33 | < 0.1% | |
| 57.22014925 | 64 | 0.1% | |
| 55.68656716 | 31 | < 0.1% | |
| 39.14552239 | 17 | < 0.1% |
| Distinct | 584 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4568.75912 |
|---|---|
| Minimum | 0 |
| Maximum | 3417602 |
| Zeros | 58829 |
| Zeros (%) | 83.6% |
| Memory size | 549.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 490 |
| Maximum | 3417602 |
| Range | 3417602 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 106920.769 |
|---|---|
| Coefficient of variation (CV) | 23.40258399 |
| Kurtosis | 951.2318377 |
| Mean | 4568.75912 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 30.32802605 |
| Sum | 321512716.8 |
| Variance | 1.143205085e+10 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 58829 | 83.6% | |
| 100 | 792 | 1.1% | |
| 25 | 673 | 1.0% | |
| 10 | 488 | 0.7% | |
| 50 | 465 | 0.7% | |
| 20 | 266 | 0.4% | |
| 200 | 264 | 0.4% | |
| 5 | 204 | 0.3% | |
| 250 | 193 | 0.3% | |
| 40 | 161 | 0.2% | |
| Other values (574) | 8037 | 11.4% |
| Value | Count | Frequency (%) | |
| 0 | 58829 | 83.6% | |
| 1 | 38 | 0.1% | |
| 1.25 | 2 | < 0.1% | |
| 1.37 | 4 | < 0.1% | |
| 2 | 92 | 0.1% |
| Value | Count | Frequency (%) | |
| 3417602 | 64 | 0.1% | |
| 2061042 | 3 | < 0.1% | |
| 1042301 | 31 | < 0.1% | |
| 461460.08 | 15 | < 0.1% | |
| 357601 | 16 | < 0.1% |
prospect_board
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 1315 |
| Value | Count | Frequency (%) | |
| 0 | 69057 | 98.1% | |
| 1 | 1315 | 1.9% |
| Distinct | 1172 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 152.239925 |
|---|---|
| Minimum | 0 |
| Maximum | 3847 |
| Zeros | 58782 |
| Zeros (%) | 83.5% |
| Memory size | 549.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1208 |
| Maximum | 3847 |
| Range | 3847 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 490.9563657 |
|---|---|
| Coefficient of variation (CV) | 3.224885757 |
| Kurtosis | 17.90792151 |
| Mean | 152.239925 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.0617276 |
| Sum | 10713428 |
| Variance | 241038.153 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 58782 | 83.5% | |
| 100 | 1248 | 1.8% | |
| 99 | 787 | 1.1% | |
| 1606 | 66 | 0.1% | |
| 277 | 64 | 0.1% | |
| 101 | 58 | 0.1% | |
| 253 | 52 | 0.1% | |
| 704 | 50 | 0.1% | |
| 209 | 49 | 0.1% | |
| 920 | 48 | 0.1% | |
| Other values (1162) | 9168 | 13.0% |
| Value | Count | Frequency (%) | |
| 0 | 58782 | 83.5% | |
| 99 | 787 | 1.1% | |
| 100 | 1248 | 1.8% | |
| 101 | 58 | 0.1% | |
| 102 | 14 | < 0.1% |
| Value | Count | Frequency (%) | |
| 3847 | 25 | < 0.1% | |
| 3823 | 6 | < 0.1% | |
| 3816 | 7 | < 0.1% | |
| 3794 | 1 | < 0.1% | |
| 3783 | 13 | < 0.1% |
first_cont_order
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 1248 |
| Value | Count | Frequency (%) | |
| 0 | 69124 | 98.2% | |
| 1 | 1248 | 1.8% |
first_cont_after
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 60817 | 86.4% | |
| 1 | 9555 | 13.6% |
rolling_tkt_sum
Real number (ℝ)
| Distinct | 4868 |
|---|---|
| Distinct (%) | 6.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.345111923 |
|---|---|
| Minimum | -0.2580645161 |
| Maximum | 495.5225806 |
| Zeros | 407 |
| Zeros (%) | 0.6% |
| Memory size | 549.8 KiB |
Quantile statistics
| Minimum | -0.2580645161 |
|---|---|
| 5-th percentile | -0.2580645161 |
| Q1 | -0.2580645161 |
| median | 0 |
| Q3 | 0.7419354839 |
| 95-th percentile | 9.575322581 |
| Maximum | 495.5225806 |
| Range | 495.7806452 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 13.53092567 |
|---|---|
| Coefficient of variation (CV) | 5.769842174 |
| Kurtosis | 426.3247918 |
| Mean | 2.345111923 |
| Median Absolute Deviation (MAD) | 0.2580645161 |
| Skewness | 17.04718958 |
| Sum | 165030.2162 |
| Variance | 183.0859496 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| -0.2580645161 | 26312 | 37.4% | |
| -0.1290322581 | 852 | 1.2% | |
| -0.1935483871 | 754 | 1.1% | |
| -0.135483871 | 715 | 1.0% | |
| 0.1870967742 | 658 | 0.9% | |
| 0.5096774194 | 621 | 0.9% | |
| 0.3806451613 | 601 | 0.9% | |
| -0.006451612903 | 564 | 0.8% | |
| -0.06451612903 | 550 | 0.8% | |
| 0.5741935484 | 462 | 0.7% | |
| Other values (4858) | 38283 | 54.4% |
| Value | Count | Frequency (%) | |
| -0.2580645161 | 26312 | 37.4% | |
| -0.2516129032 | 3 | < 0.1% | |
| -0.2451612903 | 11 | < 0.1% | |
| -0.2419354839 | 7 | < 0.1% | |
| -0.2387096774 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 495.5225806 | 2 | < 0.1% | |
| 493.0322581 | 1 | < 0.1% | |
| 452.3870968 | 2 | < 0.1% | |
| 451.6129032 | 4 | < 0.1% | |
| 451.2903226 | 1 | < 0.1% |
channel_desc_3rd Party
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 2657 |
| Value | Count | Frequency (%) | |
| 0 | 67715 | 96.2% | |
| 1 | 2657 | 3.8% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 203 |
| Value | Count | Frequency (%) | |
| 0 | 70169 | 99.7% | |
| 1 | 203 | 0.3% |
channel_desc_Chat
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 194 |
| Value | Count | Frequency (%) | |
| 0 | 70178 | 99.7% | |
| 1 | 194 | 0.3% |
channel_desc_Default Channel
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 63212 | 89.8% | |
| 1 | 7160 | 10.2% |
channel_desc_Email
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 2011 |
| Value | Count | Frequency (%) | |
| 0 | 68361 | 97.1% | |
| 1 | 2011 | 2.9% |
channel_desc_Fax
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 14 |
| Value | Count | Frequency (%) | |
| 0 | 70358 | > 99.9% | |
| 1 | 14 | < 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 5511 |
| Value | Count | Frequency (%) | |
| 0 | 64861 | 92.2% | |
| 1 | 5511 | 7.8% |
channel_desc_Mail
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 333 |
| Value | Count | Frequency (%) | |
| 0 | 70039 | 99.5% | |
| 1 | 333 | 0.5% |
channel_desc_Mobile
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 62036 | 88.2% | |
| 1 | 8336 | 11.8% |
channel_desc_Online
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 35256 | 50.1% | |
| 0 | 35116 | 49.9% |
channel_desc_Phone
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 61875 | 87.9% | |
| 1 | 8497 | 12.1% |
channel_desc_Telefunding
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 70371 | > 99.9% | |
| 1 | 1 | < 0.1% |
channel_desc_Walk Up
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 564 |
| Value | Count | Frequency (%) | |
| 0 | 69808 | 99.2% | |
| 1 | 564 | 0.8% |
MOS_desc_External
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 59247 | 84.2% | |
| 1 | 11125 | 15.8% |
MOS_desc_Internal
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 41201 | 58.5% | |
| 0 | 29171 | 41.5% |
MOS_desc_Ticketing
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 52118 | 74.1% | |
| 1 | 18254 | 25.9% |
delivery_desc_Digital
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 43240 | 61.4% | |
| 0 | 27132 | 38.6% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 948 |
| Value | Count | Frequency (%) | |
| 0 | 69424 | 98.7% | |
| 1 | 948 | 1.3% |
delivery_desc_Mail
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 59870 | 85.1% | |
| 1 | 10502 | 14.9% |
delivery_desc_Will Call
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 54426 | 77.3% | |
| 1 | 15946 | 22.7% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 38198 | 54.3% | |
| 0 | 32174 | 45.7% |
facility_desc_Fundraiser
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 1916 |
| Value | Count | Frequency (%) | |
| 0 | 68456 | 97.3% | |
| 1 | 1916 | 2.7% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 48723 | 69.2% | |
| 1 | 21649 | 30.8% |
facility_desc_Other
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 1865 |
| Value | Count | Frequency (%) | |
| 0 | 68507 | 97.3% | |
| 1 | 1865 | 2.7% |
facility_desc_Perelman
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 62351 | 88.6% | |
| 1 | 8021 | 11.4% |
facility_desc_Small venue
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 549.8 KiB |
| 0 | |
|---|---|
| 1 | 4094 |
| Value | Count | Frequency (%) | |
| 0 | 66278 | 94.2% | |
| 1 | 4094 | 5.8% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| owner_no | order_dt | tot_ticket_paid_amt | tot_contribution_paid_amt | first_order_dt | first_cont_dt | geo_area_desc | Prelim Capacity | ltv_tkt_value | Lifetime Giving | prospect_board | days_to_donation | first_cont_order | first_cont_after | rolling_tkt_sum | channel_desc_3rd Party | channel_desc_At the Performance | channel_desc_Chat | channel_desc_Default Channel | channel_desc_Email | channel_desc_Fax | channel_desc_Internal Request | channel_desc_Mail | channel_desc_Mobile | channel_desc_Online | channel_desc_Phone | channel_desc_Telefunding | channel_desc_Walk Up | MOS_desc_External | MOS_desc_Internal | MOS_desc_Ticketing | delivery_desc_Digital | delivery_desc_Do Not Print Tickets | delivery_desc_Mail | delivery_desc_Will Call | facility_desc_Academy of Music | facility_desc_Fundraiser | facility_desc_Independence Mall | facility_desc_Other | facility_desc_Perelman | facility_desc_Small venue | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 111 | 2015-10-07 | 0.753149 | 0.0 | 2015-10-07 | 1900-01-01 | 1 | 5 | 0.404851 | 0.0 | 0 | 0.0 | 0 | 0 | 0.187097 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |
| 1 | 111 | 2016-09-16 | 0.880801 | 0.0 | 2015-10-07 | 1900-01-01 | 1 | 5 | 0.404851 | 0.0 | 0 | 0.0 | 0 | 0 | 0.696774 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |
| 2 | 111 | 2018-09-21 | 0.319131 | 0.0 | 2015-10-07 | 1900-01-01 | 1 | 5 | 0.404851 | 0.0 | 0 | 0.0 | 0 | 0 | 0.922581 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |
| 3 | 258 | 2014-09-28 | 0.951010 | 0.0 | 2014-09-28 | 1900-01-01 | 5 | 6 | 0.037313 | 0.0 | 0 | 0.0 | 0 | 0 | 0.287097 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |
| 4 | 262 | 2014-10-02 | 0.159565 | 0.0 | 2014-10-02 | 1900-01-01 | 2 | 4 | -0.110075 | 0.0 | 0 | 0.0 | 0 | 0 | 0.177419 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |
| 5 | 262 | 2015-03-17 | 0.159565 | 0.0 | 2014-10-02 | 1900-01-01 | 2 | 4 | -0.110075 | 0.0 | 0 | 0.0 | 0 | 0 | 0.612903 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 6 | 267 | 2015-04-16 | -0.127652 | 0.0 | 2015-04-16 | 1900-01-01 | 1 | 6 | 3.039179 | 0.0 | 0 | 0.0 | 0 | 0 | -0.258065 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |
| 7 | 267 | 2016-04-13 | 1.774367 | 0.0 | 2015-04-16 | 1900-01-01 | 1 | 6 | 3.039179 | 0.0 | 0 | 0.0 | 0 | 0 | 0.703226 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 8 | 267 | 2016-05-03 | -0.127652 | 0.0 | 2015-04-16 | 1900-01-01 | 1 | 6 | 3.039179 | 0.0 | 0 | 0.0 | 0 | 0 | -0.258065 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 |
| 9 | 267 | 2018-05-09 | 8.808011 | 0.0 | 2015-04-16 | 1900-01-01 | 1 | 6 | 3.039179 | 0.0 | 0 | 0.0 | 0 | 0 | 5.219355 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
Last rows
| owner_no | order_dt | tot_ticket_paid_amt | tot_contribution_paid_amt | first_order_dt | first_cont_dt | geo_area_desc | Prelim Capacity | ltv_tkt_value | Lifetime Giving | prospect_board | days_to_donation | first_cont_order | first_cont_after | rolling_tkt_sum | channel_desc_3rd Party | channel_desc_At the Performance | channel_desc_Chat | channel_desc_Default Channel | channel_desc_Email | channel_desc_Fax | channel_desc_Internal Request | channel_desc_Mail | channel_desc_Mobile | channel_desc_Online | channel_desc_Phone | channel_desc_Telefunding | channel_desc_Walk Up | MOS_desc_External | MOS_desc_Internal | MOS_desc_Ticketing | delivery_desc_Digital | delivery_desc_Do Not Print Tickets | delivery_desc_Mail | delivery_desc_Will Call | facility_desc_Academy of Music | facility_desc_Fundraiser | facility_desc_Independence Mall | facility_desc_Other | facility_desc_Perelman | facility_desc_Small venue | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 70362 | 2418866 | 2016-02-08 | 0.446783 | 0.0 | 2012-10-04 | 2020-04-20 | 7 | 1 | -0.110075 | 25.0 | 0 | 2855.0 | 0 | 1 | 0.032258 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 70363 | 2418866 | 2016-02-12 | -0.127652 | 0.0 | 2012-10-04 | 2020-04-20 | 7 | 1 | -0.110075 | 25.0 | 0 | 2855.0 | 0 | 1 | -0.258065 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 |
| 70364 | 2418931 | 2018-04-25 | 1.404176 | 0.0 | 2018-04-25 | 2020-05-05 | 2 | 5 | 0.169776 | 100.0 | 0 | 841.0 | 0 | 1 | 0.516129 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 70365 | 2418999 | 2016-10-01 | -0.127652 | 20.0 | 2016-10-01 | 2016-10-01 | 1 | 3 | -0.046642 | 20.0 | 0 | 100.0 | 1 | 0 | -0.258065 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
| 70366 | 2418999 | 2017-02-13 | 0.663792 | 0.0 | 2016-10-01 | 2016-10-01 | 1 | 3 | -0.046642 | 20.0 | 0 | 100.0 | 1 | 0 | 0.141935 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 70367 | 2419011 | 2018-09-07 | -0.127652 | 25.0 | 2018-09-07 | 2018-09-07 | 2 | 5 | -0.277985 | 50.0 | 0 | 100.0 | 1 | 0 | -0.258065 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
| 70368 | 2419126 | 2019-09-19 | -0.127652 | 0.0 | 2019-09-19 | 1900-01-01 | 1 | 0 | 0.841418 | 0.0 | 0 | 0.0 | 0 | 0 | -0.258065 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |
| 70369 | 2419248 | 2017-09-20 | 2.680699 | 0.0 | 2017-09-20 | 2019-12-11 | 2 | 4 | 0.542910 | 100.0 | 0 | 912.0 | 0 | 1 | 1.161290 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 70370 | 2419278 | 2015-04-13 | 2.393481 | 0.0 | 2011-04-03 | 2003-03-26 | 1 | 3 | 1.125000 | 75.0 | 0 | 99.0 | 0 | 0 | 1.016129 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 70371 | 2419301 | 2018-01-18 | 0.638262 | 0.0 | 2018-01-18 | 1900-01-01 | 1 | 0 | -0.054104 | 0.0 | 0 | 0.0 | 0 | 0 | 0.129032 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |